CREATE VIEW |
您所在的位置:网站首页 › create or replace view as › CREATE VIEW |
OR REPLACE If a view of the same name already exists, it is replaced. To replace an existing view you must be its owner. TEMPORARY TEMPORARY views are visible only to the session that created them and are dropped when the session ends. GLOBAL TEMPORARY Applies to: Databricks Runtime GLOBAL TEMPORARY views are tied to a system preserved temporary schema global_temp. IF NOT EXISTS Creates the view only if it does not exist. If a view by this name already exists the CREATE VIEW statement is ignored. You may specify at most one of IF NOT EXISTS or OR REPLACE. view_name The name of the newly created view. A temporary view鈥檚 name must not be qualified. The fully qualified view name must be unique. column_list Optionally labels the columns in the query result of the view. If you provide a column list the number of column aliases must match the number of expressions in the query. In case no column list is specified aliases are derived from the body of the view. column_alias The column aliases must be unique. column_comment An optional STRING literal describing the column alias. view_comment An optional STRING literal providing a view-level comments. TBLPROPERTIES Optionally sets one or more user defined properties. AS query A query that constructs the view from base tables or other views. |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |